﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
<title>长沙租房网数据库手册</title>
<style type="text/css">
body {font-family:verdana;font-size:12px;}
h1,{font:700 28px/36px "MingLiu";color:#05c;}
hr {border:1px inset #fff;}
table {border-bottom:1px solid #06c;}
table th {background-color:#06c;height:26px;text-align:center;color:#fff;font-size:14px;}
caption {text-align:left;font:700 16px/24px arial;padding:1em 0;}
td {padding-left:10px;height:22px;background-color:#F4F9FF;}
tr.cur td {background-color:#E6F0FF;}
.w1 {text-align:center;padding:0;}
</style>
</head>

<body>
<h1>长沙租房网数据库手册</h1>
<hr />
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		信息表-[Info]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>Title</td>
		<td>Varchar(50)</td>
		<td>信息标题</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>Remark</td>
		<td>Text</td>
		<td>信息备注</td>
	</tr>
	<tr class="cur">
		<td class="w1">4</td>
		<td>Path</td>
		<td>Varchar(100)</td>
		<td>信息路径</td>
	</tr>
	<tr>
		<td class="w1">5</td>
		<td>UserName</td>
		<td>Varchar(16)</td>
		<td>发布者姓名</td>
	</tr>
	<tr class="cur">
		<td class="w1">6</td>
		<td>Phone</td>
		<td>Varchar(50)</td>
		<td>发布者座机，家庭电话</td>
	</tr>
	<tr>
		<td class="w1">7</td>
		<td>Mobile</td>
		<td>Varchar(50)</td>
		<td>发布者手机</td>
	</tr>
	<tr class="cur">
		<td class="w1">8</td>
		<td>QQ</td>
		<td>Varchar(50)</td>
		<td>发布者QQ</td>
	</tr>
	<tr>
		<td class="w1">9</td>
		<td>Email</td>
		<td>Varchar(50)</td>
		<td>发布者电子邮箱</td>
	</tr>
	<tr class="cur">
		<td class="w1">10</td>
		<td>UserID</td>
		<td>Int</td>
		<td>已注册用户的ID</td>
	</tr>
	<tr>
		<td class="w1">11</td>
		<td>DistrictID</td>
		<td>Int</td>
		<td>所属地区ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">12</td>
		<td>ClassID</td>
		<td>Int</td>
		<td>所属信息分类ID</td>
	</tr>
	<tr>
		<td class="w1">13</td>
		<td>Room</td>
		<td>Int</td>
		<td>室</td>
	</tr>
	<tr class="cur">
		<td class="w1">14</td>
		<td>Hall</td>
		<td>Int</td>
		<td>厅</td>
	</tr>
	<tr>
		<td class="w1">15</td>
		<td>Toilet</td>
		<td>Int</td>
		<td>卫</td>
	</tr>
	<tr class="cur">
		<td class="w1">16</td>
		<td>Veranda</td>
		<td>Int</td>
		<td>阳台</td>
	</tr>
	<tr>
		<td class="w1">17</td>
		<td>Area</td>
		<td>Int</td>
		<td>面积</td>
	</tr>
	<tr class="cur">
		<td class="w1">18</td>
		<td>Price</td>
		<td>Int</td>
		<td>价格</td>
	</tr>
	<tr>
		<td class="w1">19</td>
		<td>BuildTime</td>
		<td>Int</td>
		<td>建筑年代</td>
	</tr>
	<tr class="cur">
		<td class="w1">20</td>
		<td>PriceUnit</td>
		<td>Varchar(10)</td>
		<td>价格类型：元/每月，万元等</td>
	</tr>
	<tr>
		<td class="w1">21</td>
		<td>Floor</td>
		<td>Varchar(10)</td>
		<td>楼层：3/20</td>
	</tr>
	<tr class="cur">
		<td class="w1">22</td>
		<td>RentType</td>
		<td>Int</td>
		<td>租赁方式：整租，合租</td>
	</tr>
	<tr>
		<td class="w1">23</td>
		<td>HouseType</td>
		<td>Varchar(10)</td>
		<td>房型：多层住宅，小高层住宅，高层住宅，公寓，商住楼，厂房</td>
	</tr>
	<tr class="cur">
		<td class="w1">24</td>
		<td>Ownership</td>
		<td>Varchar(10)</td>
		<td>房屋产权：商品房，公房，私房</td>
	</tr>
	<tr>
		<td class="w1">25</td>
		<td>Decoration</td>
		<td>Varchar(10)</td>
		<td>装修程度</td>
	</tr>
	<tr class="cur">
		<td class="w1">26</td>
		<td>Region</td>
		<td>Varchar(20)</td>
		<td>具体位置</td>
	</tr>
	<tr>
		<td class="w1">27</td>
		<td>Agency</td>
		<td>Bit</td>
		<td>是否中介</td>
	</tr>
	<tr class="cur">
		<td class="w1">28</td>
		<td>Station</td>
		<td>Varchar(20)</td>
		<td>所处公交车站</td>
	</tr>
	<tr>
		<td class="w1">29</td>
		<td>RentMinDays</td>
		<td>Int</td>
		<td>最短租期：一季度，半年，一年</td>
	</tr>
	<tr class="cur">
		<td class="w1">30</td>
		<td>PubTime</td>
		<td>DateTime</td>
		<td>信息发布时间</td>
	</tr>
	<tr>
		<td class="w1">31</td>
		<td>PubIP</td>
		<td>Varchar(20)</td>
		<td>发布者IP</td>
	</tr>
	<tr class="cur">
		<td class="w1">32</td>
		<td>Hots</td>
		<td>Int</td>
		<td>信息浏览次数</td>
	</tr>
	<tr>
		<td class="w1">33</td>
		<td>Flag</td>
		<td>Bit</td>
		<td>是否通过审核</td>
	</tr>
	<tr class="cur">
		<td class="w1">34</td>
		<td>Vcode</td>
		<td>Varchar(20)</td>
		<td>自助管理的验证码</td>
	</tr>
	<tr>
		<td class="w1">35</td>
		<td>Utilities</td>
		<td>Varchar(20)</td>
		<td>房屋的配套设施：厨房  床  家具  有线电视  宽带网</td>
	</tr>
	<tr class="cur">
		<td class="w1">36</td>
		<td>UpdateTime</td>
		<td>DateTime</td>
		<td>信息刷新时间</td>
	</tr>
	<tr>
		<td class="w1">37</td>
		<td>PaymentTerms</td>
		<td>Varchar(10)</td>
		<td>付款要求：一月一付 一季一付 半年一付 一年一付</td>
	</tr>
	<tr class="cur">
		<td class="w1">38</td>
		<td>DepositTerms</td>
		<td>Varchar(10)</td>
		<td>押金要求：半月租金 一月租金 两月租金 一季租金</td>
	</tr>
	<tr>
		<td class="w1">39</td>
		<td>Remind</td>
		<td>Bit</td>
		<td>邮件提醒用户更新超过30天，且没有完成交易的信息！</td>
	</tr>
	<tr class="cur">
		<td class="w1">40</td>
		<td>RemindTime</td>
		<td>DateTime</td>
		<td>邮件提醒时间</td>
	</tr>
	<tr>
		<td class="w1">41</td>
		<td>RentTypeSex</td>
		<td>Int</td>
		<td>租赁方式：限男性，限女性，性别不限。</td>
	</tr>
	<tr class="cur">
		<td class="w1">42</td>
		<td>ValidityTime</td>
		<td>DateTime</td>
		<td>信息有效时间</td>
	</tr>
	<tr>
		<td class="w1">43</td>
		<td>AgencyId</td>
		<td>Int</td>
		<td>中介房源编号</td>
	</tr>
	<tr class="cur">
		<td class="w1">44</td>
		<td>Trade</td>
		<td>Bit</td>
		<td>信息是否交易成功</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		用户表-[User]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>LoginName</td>
		<td>Varchar(16)</td>
		<td>登陆名，用户名</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>NickName</td>
		<td>Varchar(16)</td>
		<td>姓名，昵称</td>
	</tr>
	<tr class="cur">
		<td class="w1">4</td>
		<td>Password</td>
		<td>Varchar(32)</td>
		<td>密码，MD5 32位加密串</td>
	</tr>
	<tr>
		<td class="w1">5</td>
		<td>Mobile</td>
		<td>Varchar(20)</td>
		<td>用户移动电话</td>
	</tr>
	<tr class="cur">
		<td class="w1">6</td>
		<td>Phone</td>
		<td>Varchar(20)</td>
		<td>用户联系电话（座机）</td>
	</tr>
	<tr>
		<td class="w1">7</td>
		<td>QQ</td>
		<td>Varchar(50)</td>
		<td>用户联系QQ</td>
	</tr>
	<tr class="cur">
		<td class="w1">8</td>
		<td>Email</td>
		<td>Varchar(50)</td>
		<td>用户电子邮箱，可做登陆</td>
	</tr>
	<tr>
		<td class="w1">9</td>
		<td>Address</td>
		<td>Varchar(200)</td>
		<td>联系地址</td>
	</tr>
	<tr class="cur">
		<td class="w1">10</td>
		<td>HeadPicPath</td>
		<td>Varchar(200)</td>
		<td>用户头像路径</td>
	</tr>
	<tr>
		<td class="w1">11</td>
		<td>Money</td>
		<td>Int</td>
		<td>账户可用余额</td>
	</tr>
	<tr class="cur">
		<td class="w1">12</td>
		<td>InfoTotal</td>
		<td>Int</td>
		<td>用户发布信息总数。</td>
	</tr>
	<tr>
		<td class="w1">13</td>
		<td>UpdateTime</td>
		<td>DateTime</td>
		<td>最后登陆日期</td>
	</tr>
	<tr class="cur">
		<td class="w1">14</td>
		<td>RegTime</td>
		<td>DateTime</td>
		<td>注册日期</td>
	</tr>
	<tr>
		<td class="w1">15</td>
		<td>RegIP</td>
		<td>Varchar(50)</td>
		<td>注册IP</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		消息表-[Message]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>Title</td>
		<td>Varchar(200)</td>
		<td>消息标题</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>Content</td>
		<td>Text</td>
		<td>消息内容</td>
	</tr>
	<tr class="cur">
		<td class="w1">4</td>
		<td>MsgFromUserID</td>
		<td>Int</td>
		<td>消息来自，消息发送者ID</td>
	</tr>
	<tr>
		<td class="w1">6</td>
		<td>MsgToUserID</td>
		<td>Int</td>
		<td>消息发送的对象，消息接受者ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">5</td>
		<td>SendTime</td>
		<td>DateTime</td>
		<td>消息发送时间</td>
	</tr>
	<tr>
		<td class="w1">7</td>
		<td>Ready</td>
		<td>Bit</td>
		<td>消息是否以查看</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		用户反馈表-[Feedback]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>UserName</td>
		<td>Varchar(16)</td>
		<td>用户姓名</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>Content</td>
		<td>Text</td>
		<td>反馈内容</td>
	</tr>
	<tr class="cur">
		<td class="w1">4</td>
		<td>Contact</td>
		<td>Varchar(50)</td>
		<td>用户联系方式</td>
	</tr>
	<tr>
		<td class="w1">6</td>
		<td>Types</td>
		<td>Varchar(10)</td>
		<td>反馈问题类型</td>
	</tr>
	<tr class="cur">
		<td class="w1">5</td>
		<td>SubTime</td>
		<td>DateTime</td>
		<td>反馈的时间</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		地区分类表-[District]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>Name</td>
		<td>Varchar(50)</td>
		<td>地区名</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>OrderNum</td>
		<td>Int</td>
		<td>排序数字，数字大的排前面</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		信息分类表-[Class]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>Name</td>
		<td>Varchar(50)</td>
		<td>地区名</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>OrderNum</td>
		<td>Int</td>
		<td>排序数字，数字大的排前面</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		资金流表-[Finance]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>Amount</td>
		<td>Int</td>
		<td>金额总数</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>Remarks</td>
		<td>Varchar(100)</td>
		<td>资金流动原由，用来做了什么，描述，备注。</td>
	</tr>
	<tr class="cur">
		<td class="w1">4</td>
		<td>AlterType</td>
		<td>Bit</td>
		<td>资金流类型，充值或消费。</td>
	</tr>
	<tr>
		<td class="w1">5</td>
		<td>UserID</td>
		<td>Int</td>
		<td>用户ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">6</td>
		<td>TheDate</td>
		<td>DateTime</td>
		<td>资金流动日期</td>
	</tr>
	<tr>
		<td class="w1">7</td>
		<td>AlterIP</td>
		<td>Varchar(50)</td>
		<td>资金流动IP</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		文章分类表-[ArticleClass]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>Name</td>
		<td>Varchar(50)</td>
		<td>分类名称</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>BigID</td>
		<td>Int</td>
		<td>所属大类ID</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		文章表-[Article]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>Title</td>
		<td>Varchar(100)</td>
		<td>文章标题</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>Content</td>
		<td>Text</td>
		<td>文章内容</td>
	</tr>
	<tr class="cur">
		<td class="w1">4</td>
		<td>Tags</td>
		<td>Varchar(50)</td>
		<td>文章关键词</td>
	</tr>
	<tr>
		<td class="w1">5</td>
		<td>LitPic</td>
		<td>Varchar(100)</td>
		<td>缩略图</td>
	</tr>
	<tr class="cur">
		<td class="w1">6</td>
		<td>Source</td>
		<td>Varchar(50)</td>
		<td>文章来源</td>
	</tr>
	<tr>
		<td class="w1">7</td>
		<td>PubDate</td>
		<td>DateTime</td>
		<td>文章添加日期</td>
	</tr>
	<tr class="cur">
		<td class="w1">8</td>
		<td>Hits</td>
		<td>Int</td>
		<td>文章点击次数</td>
	</tr>
	<tr>
		<td class="w1">9</td>
		<td>Best</td>
		<td>Bit</td>
		<td>是否为推荐文章</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		帮助分类表-[HelpClass]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>Name</td>
		<td>Varchar(50)</td>
		<td>分类名称</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>BigID</td>
		<td>ID</td>
		<td>所属大类ID</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
	<caption>
		帮助内容表-[HelpContent]
	</caption>
	<tr>
		<th width="40" scope="col">序列</th>
		<th width="160" scope="col">字段名</th>
		<th width="160" scope="col">数据类型</th>
		<th scope="col">备注说明</th>
	</tr>
	<tr>
		<td class="w1">1</td>
		<td>ID</td>
		<td>Int</td>
		<td>ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">2</td>
		<td>HelpContent</td>
		<td>Text</td>
		<td>帮助内容</td>
	</tr>
	<tr>
		<td class="w1">3</td>
		<td>BID</td>
		<td>Int</td>
		<td>所属大类ID</td>
	</tr>
	<tr class="cur">
		<td class="w1">4</td>
		<td>SID</td>
		<td>Int</td>
		<td>所属小类ID</td>
	</tr>
</table>
</body>
</html>
